SSIS: 将SQL结果存入变量 Select SQL result into variable

Categories: Database; Tagged with: ETL • SQL Server • SSIS; @ December 14th, 2012 18:42

1. 修改SQL Task 的Result Set属性

2. 在ResultSet tab下选择要输出的Column及对应的Variable：

在Flex中使用JSON新手入门: 读取豆瓣API <-> SSIS: 在OLE DB Source SQL Command中使用Variable | Using variable in the SQL Command of OLE DB Source

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects